SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vw_consultabonifacio
AS
SELECT     dbo.tb_SubsidNico.CUISE, dbo.tb_SubsidNico.FECHA, dbo.tb_SubsidNico.Expediente, dbo.tb_SubsidNico.RESOLUCION, dbo.tb_SubsidNico.MONTO, 
                      dbo.tb_SubsidNico.INTERMEDIARIO, dbo.tb_SubsidNico.LOCALIDAD, dbo.tb_SubsidNico.CONCEPTO, dbo.AlumnosEscuela.CAT, 
                      dbo.AlumnosEscuela.Total1CICLO, dbo.AlumnosEscuela.Total2CICLO, dbo.AlumnosEscuela.Total3CICLO, dbo.AlumnosEscuela.TotalPolimodal, 
                      dbo.AlumnosEscuela.TotaldeAlumnos
FROM         dbo.tb_SubsidNico INNER JOIN
                      dbo.AlumnosEscuela ON dbo.tb_SubsidNico.CUISE = dbo.AlumnosEscuela.CUISE

GO
